Lesson 20 lect004

Adding Data

In the previous lesson you completed the first step, creating a table. Now you will complete the second step, entering data into the table.

Our Store database will include the following data:

Trans ItemNo SDate Descript Dept Qty Price Sale

1 2344 10/27/97 Hard Candy Candy 1 $2.59 Yes

2 2345 11/01/98 Candy Bar Candy 3 $1.00 No

3 3321 12/14/98 Soap Grocery 4 $3.69 No

4 4215 12/11/98 Pan Kitchen 6 $9.99 No

5 5216 04/28/99 Corn Produce 2 $1.29 No

6 9874 05/03/99 Apple Produce 3 $1.59 No

7 7371 06/09/99 Crackers Grocery 9 $2.39 Yes

8 1921 07/04/99 Beef Meat 2 $5.49 No

9 9873 08/31/99 Milk Dairy 7 $2.69 No

10 2321 12/31/99 Chocolate Candy 7 $8.59 Yes

Now on to adding data to your table!

Trans	ItemNo	SDate	Descript	Dept	Qty	Price	Sale
1	2344	10/27/97	Hard Candy	Candy	1	$2.59	Yes
2	2345	11/01/98	Candy Bar	Candy	3	$1.00	No
3	3321	12/14/98	Soap	Grocery	4	$3.69	No
4	4215	12/11/98	Pan	Kitchen	6	$9.99	No
5	5216	04/28/99	Corn	Produce	2	$1.29	No
6	9874	05/03/99	Apple	Produce	3	$1.59	No
7	7371	06/09/99	Crackers	Grocery	9	$2.39	Yes
8	1921	07/04/99	Beef	Meat	2	$5.49	No
9	9873	08/31/99	Milk	Dairy	7	$2.69	No
10	2321	12/31/99	Chocolate	Candy	7	$8.59	Yes